Dataset info
| Number of variables | 67 |
|---|---|
| Number of observations | 13604 |
| Missing cells | 101152 (11.1%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 7.0 MiB |
| Average record size in memory | 536.0 B |
Variables types
| Numeric | 34 |
|---|---|
| Categorical | 2 |
| Boolean | 0 |
| Date | 0 |
| URL | 0 |
| Text (Unique) | 1 |
| Rejected | 30 |
| Unsupported | 0 |
Warnings
avg_cash_1m is highly skewed (γ1 = 103.689676) | Skewed |
avg_cash_1m has 1794 (13.2%) missing values | Missing |
avg_cash_3m is highly correlated with avg_cash_1m (ρ = 0.999099545) | Rejected |
avg_cash_6m is highly correlated with avg_cash_3m (ρ = 0.9936676512) | Rejected |
avg_loan_1m has 9723 (71.5%) missing values | Missing |
avg_loan_3m is highly correlated with avg_loan_1m (ρ = 0.982995212) | Rejected |
avg_loan_6m is highly correlated with avg_loan_3m (ρ = 0.9830235048) | Rejected |
avg_portfolio_value_1m is highly skewed (γ1 = 57.17590837) | Skewed |
avg_portfolio_value_3m is highly correlated with avg_portfolio_value_1m (ρ = 0.994578141) | Rejected |
avg_portfolio_value_6m is highly correlated with avg_portfolio_value_3m (ρ = 0.9904928022) | Rejected |
avg_profit_per_6m has 6566 (48.3%) missing values | Missing |
avg_stock_count_1m is highly skewed (γ1 = 35.66018242) | Skewed |
avg_stock_count_3m is highly correlated with avg_stock_count_1m (ρ = 0.9902316431) | Rejected |
avg_stock_count_6m is highly correlated with avg_stock_count_3m (ρ = 0.9945684363) | Rejected |
buy_order has 11966 (88.0%) zeros | Zeros |
buy_order_1m has 7919 (58.2%) zeros | Zeros |
buy_order_3m has 5945 (43.7%) zeros | Zeros |
buy_order_6m is highly correlated with buy_order_3m (ρ = 0.9541051671) | Rejected |
buy_orders_1m_3m_per has 1974 (14.5%) zeros | Zeros |
buy_orders_1m_6m_per has 3104 (22.8%) zeros | Zeros |
cash_vs_1m has 6937 (51.0%) zeros | Zeros |
cash_vs_1m has 2142 (15.7%) missing values | Missing |
cash_vs_3m is highly correlated with cash_vs_1m (ρ = 0.9177938753) | Rejected |
cash_vs_6m is highly correlated with cash_vs_3m (ρ = 0.9191843439) | Rejected |
CashBalance is highly correlated with cash_vs_6m (ρ = 0.9575212639) | Rejected |
loan_vs_1m has 406 (3.0%) zeros | Zeros |
loan_vs_1m has 10235 (75.2%) missing values | Missing |
loan_vs_3m has 10235 (75.2%) missing values | Missing |
loan_vs_6m is highly correlated with loan_vs_3m (ρ = 0.9634403754) | Rejected |
LoanBalance is highly correlated with avg_loan_3m (ρ = 0.9520490662) | Rejected |
num_oder has 11385 (83.7%) zeros | Zeros |
port_value_vs_1m is highly skewed (γ1 = 56.33449157) | Skewed |
port_value_vs_1m has 333 (2.4%) zeros | Zeros |
port_value_vs_3m has 257 (1.9%) zeros | Zeros |
port_value_vs_6m is highly correlated with port_value_vs_3m (ρ = 0.9076132457) | Rejected |
portfolio_value is highly correlated with avg_portfolio_value_6m (ρ = 0.9673778626) | Rejected |
profit is highly skewed (γ1 = 25.84513152) | Skewed |
profit has 12447 (91.5%) zeros | Zeros |
profit_1m has 8893 (65.4%) zeros | Zeros |
profit_3m is highly skewed (γ1 = 115.58013) | Skewed |
profit_3m has 7316 (53.8%) zeros | Zeros |
profit_6m is highly correlated with profit_3m (ρ = 0.9943629294) | Rejected |
profit_per has 12437 (91.4%) missing values | Missing |
region has a high cardinality: 71 distinct values | Warning |
sell_order has 12437 (91.4%) zeros | Zeros |
sell_order_1m has 8865 (65.2%) zeros | Zeros |
sell_order_3m is highly correlated with sell_order_1m (ρ = 0.9065289845) | Rejected |
sell_order_6m is highly correlated with sell_order_3m (ρ = 0.9577278331) | Rejected |
sell_order_gain has 12944 (95.1%) zeros | Zeros |
sell_order_loss has 12942 (95.1%) zeros | Zeros |
sell_orders_1m_3m_per has 1568 (11.5%) zeros | Zeros |
sell_orders_1m_6m_per has 2299 (16.9%) zeros | Zeros |
stock_count is highly correlated with avg_stock_count_6m (ρ = 0.967179082) | Rejected |
stock_count_vs_1m has 10985 (80.7%) zeros | Zeros |
stock_count_vs_3m has 9952 (73.2%) zeros | Zeros |
stock_count_vs_6m is highly correlated with stock_count_vs_3m (ρ = 0.9005250291) | Rejected |
total_buy_order_1m_3m_per is highly correlated with buy_orders_1m_3m_per (ρ = 0.9809048155) | Rejected |
total_buy_order_1m_6m_per is highly correlated with buy_orders_1m_6m_per (ρ = 0.9834419742) | Rejected |
total_buy_value is highly skewed (γ1 = 33.59928488) | Skewed |
total_buy_value has 11966 (88.0%) zeros | Zeros |
total_buy_value_1m is highly skewed (γ1 = 111.4168123) | Skewed |
total_buy_value_1m has 7920 (58.2%) zeros | Zeros |
total_buy_value_3m is highly correlated with total_buy_value_1m (ρ = 0.9484353291) | Rejected |
total_buy_value_6m is highly skewed (γ1 = 99.82045008) | Skewed |
total_buy_value_6m has 4822 (35.4%) zeros | Zeros |
total_sell_order_1m_3m_per is highly correlated with sell_orders_1m_3m_per (ρ = 0.9806879469) | Rejected |
total_sell_order_1m_6m_per is highly correlated with sell_orders_1m_6m_per (ρ = 0.9863198197) | Rejected |
total_sell_value is highly skewed (γ1 = 32.59792884) | Skewed |
total_sell_value has 12437 (91.4%) zeros | Zeros |
total_sell_value_1m is highly skewed (γ1 = 76.04338338) | Skewed |
total_sell_value_1m has 8867 (65.2%) zeros | Zeros |
total_sell_value_3m is highly correlated with profit_6m (ρ = 0.9617840254) | Rejected |
total_sell_value_6m is highly correlated with total_sell_value_3m (ρ = 0.988218788) | Rejected |
trading_date has constant value "2019-09-30" | Rejected |
trading_month has constant value "9" | Rejected |
Age
Numeric
| Distinct count | 79 |
|---|---|
| Unique (%) | 0.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 39.34776536 |
|---|---|
| Minimum | 0 |
| Maximum | 94 |
| Zeros (%) | 0.9% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 24 |
| Q1 | 31 |
| Median | 38 |
| Q3 | 45 |
| 95-th percentile | 62 |
| Maximum | 94 |
| Range | 94 |
| Interquartile range | 14 |
Descriptive statistics
| Standard deviation | 11.78569364 |
|---|---|
| Coef of variation | 0.299526378 |
| Kurtosis | 1.096228827 |
| Mean | 39.34776536 |
| MAD | 9.008705951 |
| Skewness | 0.4923783728 |
| Sum | 535287 |
| Variance | 138.9025746 |
| Memory size | 106.4 KiB |
| Value | Count | Frequency (%) | |
| 36 | 639 | 4.7% | |
| 35 | 632 | 4.6% | |
| 38 | 571 | 4.2% | |
| 37 | 567 | 4.2% | |
| 34 | 545 | 4.0% | |
| 30 | 515 | 3.8% | |
| 32 | 502 | 3.7% | |
| 39 | 497 | 3.7% | |
| 31 | 493 | 3.6% | |
| 29 | 468 | 3.4% | |
| Other values (69) | 8175 | 60.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 116 | 0.9% | |
| 3 | 1 | < 0.1% | |
| 4 | 4 | < 0.1% | |
| 6 | 1 | < 0.1% | |
| 9 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 94 | 1 | < 0.1% | |
| 89 | 1 | < 0.1% | |
| 88 | 1 | < 0.1% | |
| 87 | 1 | < 0.1% | |
| 86 | 1 | < 0.1% |
avg_cash_1m
Numeric
| Distinct count | 11592 |
|---|---|
| Unique (%) | 85.2% |
| Missing (%) | 13.2% |
| Missing (n) | 1794 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 91789808.97 |
|---|---|
| Minimum | 1 |
| Maximum | 5.868472227e+11 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2453.75 |
| Q1 | 98256 |
| Median | 943260.725 |
| Q3 | 8656386.975 |
| 95-th percentile | 102519827.9 |
| Maximum | 5.868472227e+11 |
| Range | 5.868472227e+11 |
| Interquartile range | 8558130.975 |
Descriptive statistics
| Standard deviation | 5495863568 |
|---|---|
| Coef of variation | 59.87444173 |
| Kurtosis | 11016.55324 |
| Mean | 91789808.97 |
| MAD | 159437380.5 |
| Skewness | 103.689676 |
| Sum | 1.084037644e+12 |
| Variance | 3.020451636e+19 |
| Memory size | 106.4 KiB |
| Value | Count | Frequency (%) | |
| 220064 | 16 | 0.1% | |
| 342414 | 10 | 0.1% | |
| 1 | 7 | 0.1% | |
| 17 | 5 | < 0.1% | |
| 219 | 5 | < 0.1% | |
| 5 | 5 | < 0.1% | |
| 179 | 5 | < 0.1% | |
| 2300 | 4 | < 0.1% | |
| 71 | 4 | < 0.1% | |
| 1096 | 4 | < 0.1% | |
| Other values (11581) | 11745 | 86.3% | |
| (Missing) | 1794 | 13.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 7 | 0.1% | |
| 2 | 2 | < 0.1% | |
| 3 | 2 | < 0.1% | |
| 4 | 2 | < 0.1% | |
| 5 | 5 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 5.868472227e+11 | 1 | < 0.1% | |
| 1.066013554e+11 | 1 | < 0.1% | |
| 1.661310946e+10 | 1 | < 0.1% | |
| 1.402131235e+10 | 1 | < 0.1% | |
| 1.172530387e+10 | 1 | < 0.1% |
avg_cash_3m
Highly correlated
This variable is highly correlated with avg_cash_1m and should be ignored for analysis
| Correlation | 0.999099545 |
|---|
avg_cash_6m
Highly correlated
This variable is highly correlated with avg_cash_3m and should be ignored for analysis
| Correlation | 0.9936676512 |
|---|
avg_loan_1m
Numeric
| Distinct count | 3880 |
|---|---|
| Unique (%) | 28.5% |
| Missing (%) | 71.5% |
| Missing (n) | 9723 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1079097733 |
|---|---|
| Minimum | 1 |
| Maximum | 1.761755415e+11 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1029127 |
| Q1 | 29696319 |
| Median | 113664492.8 |
| Q3 | 384190409.4 |
| 95-th percentile | 3110180832 |
| Maximum | 1.761755415e+11 |
| Range | 1.761755415e+11 |
| Interquartile range | 354494090.4 |
Descriptive statistics
| Standard deviation | 6563522764 |
|---|---|
| Coef of variation | 6.082417344 |
| Kurtosis | 339.9789419 |
| Mean | 1079097733 |
| MAD | 1590451153 |
| Skewness | 16.23951948 |
| Sum | 4.1879783e+12 |
| Variance | 4.307983107e+19 |
| Memory size | 106.4 KiB |
| Value | Count | Frequency (%) | |
| 2 | 3 | < 0.1% | |
| 587101517.6 | 1 | < 0.1% | |
| 8300358 | 1 | < 0.1% | |
| 128178611.4 | 1 | < 0.1% | |
| 215276311 | 1 | < 0.1% | |
| 8473931 | 1 | < 0.1% | |
| 857295 | 1 | < 0.1% | |
| 3184863297 | 1 | < 0.1% | |
| 644665.8947 | 1 | < 0.1% | |
| 51720091.75 | 1 | < 0.1% | |
| Other values (3869) | 3869 | 28.4% | |
| (Missing) | 9723 | 71.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 1 | < 0.1% | |
| 2 | 3 | < 0.1% | |
| 5 | 1 | < 0.1% | |
| 9 | 1 | < 0.1% | |
| 13 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1.761755415e+11 | 1 | < 0.1% | |
| 1.62746467e+11 | 1 | < 0.1% | |
| 1.501863354e+11 | 1 | < 0.1% | |
| 1.017458212e+11 | 1 | < 0.1% | |
| 9.688517257e+10 | 1 | < 0.1% |
avg_loan_3m
Highly correlated
This variable is highly correlated with avg_loan_1m and should be ignored for analysis
| Correlation | 0.982995212 |
|---|
avg_loan_6m
Highly correlated
This variable is highly correlated with avg_loan_3m and should be ignored for analysis
| Correlation | 0.9830235048 |
|---|
avg_portfolio_value_1m
Numeric
| Distinct count | 12413 |
|---|---|
| Unique (%) | 91.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3511439829 |
|---|---|
| Minimum | 0 |
| Maximum | 6.726841428e+12 |
| Zeros (%) | 0.8% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 52717.25 |
| Q1 | 2912511.625 |
| Median | 46092690 |
| Q3 | 255812375 |
| 95-th percentile | 2360454725 |
| Maximum | 6.726841428e+12 |
| Range | 6.726841428e+12 |
| Interquartile range | 252899863.4 |
Descriptive statistics
| Standard deviation | 8.041718837e+10 |
|---|---|
| Coef of variation | 22.90148551 |
| Kurtosis | 4125.929071 |
| Mean | 3511439829 |
| MAD | 6319753027 |
| Skewness | 57.17590837 |
| Sum | 4.776962744e+13 |
| Variance | 6.466924185e+21 |
| Memory size | 106.4 KiB |
| Value | Count | Frequency (%) | |
| 0 | 106 | 0.8% | |
| 271375 | 67 | 0.5% | |
| 167000 | 49 | 0.4% | |
| 62625 | 44 | 0.3% | |
| 41750 | 40 | 0.3% | |
| 61965 | 34 | 0.2% | |
| 146125 | 33 | 0.2% | |
| 229625 | 32 | 0.2% | |
| 2254965 | 31 | 0.2% | |
| 343477250 | 25 | 0.2% | |
| Other values (12403) | 13143 | 96.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 106 | 0.8% | |
| 1000 | 1 | < 0.1% | |
| 1320 | 1 | < 0.1% | |
| 1400 | 1 | < 0.1% | |
| 1500 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 6.726841428e+12 | 1 | < 0.1% | |
| 3.895901932e+12 | 1 | < 0.1% | |
| 2.372319836e+12 | 1 | < 0.1% | |
| 1.9923722e+12 | 1 | < 0.1% | |
| 1.734016099e+12 | 1 | < 0.1% |
avg_portfolio_value_3m
Highly correlated
This variable is highly correlated with avg_portfolio_value_1m and should be ignored for analysis
| Correlation | 0.994578141 |
|---|
avg_portfolio_value_6m
Highly correlated
This variable is highly correlated with avg_portfolio_value_3m and should be ignored for analysis
| Correlation | 0.9904928022 |
|---|
avg_profit_per_6m
Numeric
| Distinct count | 6925 |
|---|---|
| Unique (%) | 50.9% |
| Missing (%) | 48.3% |
| Missing (n) | 6566 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.007628454389 |
|---|---|
| Minimum | -1 |
| Maximum | 3.711188321 |
| Zeros (%) | 0.3% |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | -0.1130861688 |
| Q1 | -0.02931301111 |
| Median | -0.004450231505 |
| Q3 | 0.02467667158 |
| 95-th percentile | 0.1627218557 |
| Maximum | 3.711188321 |
| Range | 4.711188321 |
| Interquartile range | 0.05398968269 |
Descriptive statistics
| Standard deviation | 0.1288179404 |
|---|---|
| Coef of variation | 16.88650595 |
| Kurtosis | 150.3202316 |
| Mean | 0.007628454389 |
| MAD | 0.06029826319 |
| Skewness | 6.896232708 |
| Sum | 53.68906199 |
| Variance | 0.01659406178 |
| Memory size | 106.4 KiB |
| Value | Count | Frequency (%) | |
| 0 | 36 | 0.3% | |
| -1 | 5 | < 0.1% | |
| -0.06015037594 | 4 | < 0.1% | |
| 0.02510460251 | 4 | < 0.1% | |
| 0.1 | 3 | < 0.1% | |
| 0.07692307692 | 3 | < 0.1% | |
| 0.1052631579 | 3 | < 0.1% | |
| 0.02941176471 | 3 | < 0.1% | |
| -0.03759398496 | 3 | < 0.1% | |
| -0.1578947368 | 3 | < 0.1% | |
| Other values (6914) | 6971 | 51.2% | |
| (Missing) | 6566 | 48.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -1 | 5 | < 0.1% | |
| -0.9249146758 | 1 | < 0.1% | |
| -0.8531955146 | 1 | < 0.1% | |
| -0.7726784756 | 1 | < 0.1% | |
| -0.6626180837 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 3.711188321 | 1 | < 0.1% | |
| 2.743654822 | 1 | < 0.1% | |
| 1.676056338 | 1 | < 0.1% | |
| 1.610399146 | 1 | < 0.1% | |
| 1.444444444 | 1 | < 0.1% |
avg_stock_count_1m
Numeric
| Distinct count | 650 |
|---|---|
| Unique (%) | 4.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3.156561785 |
|---|---|
| Minimum | 1 |
| Maximum | 393 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 2 |
| Q3 | 4 |
| 95-th percentile | 9 |
| Maximum | 393 |
| Range | 392 |
| Interquartile range | 3 |
Descriptive statistics
| Standard deviation | 5.183603105 |
|---|---|
| Coef of variation | 1.642167478 |
| Kurtosis | 2424.765045 |
| Mean | 3.156561785 |
| MAD | 2.223472217 |
| Skewness | 35.66018242 |
| Sum | 42941.86652 |
| Variance | 26.86974115 |
| Memory size | 106.4 KiB |
| Value | Count | Frequency (%) | |
| 1 | 5012 | 36.8% | |
| 2 | 1732 | 12.7% | |
| 3 | 917 | 6.7% | |
| 4 | 576 | 4.2% | |
| 5 | 338 | 2.5% | |
| 6 | 214 | 1.6% | |
| 7 | 135 | 1.0% | |
| 8 | 104 | 0.8% | |
| 9 | 63 | 0.5% | |
| 10 | 60 | 0.4% | |
| Other values (640) | 4453 | 32.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 5012 | 36.8% | |
| 1.05 | 52 | 0.4% | |
| 1.052631579 | 8 | 0.1% | |
| 1.055555556 | 1 | < 0.1% | |
| 1.058823529 | 4 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 393 | 1 | < 0.1% | |
| 121.2 | 1 | < 0.1% | |
| 119.75 | 1 | < 0.1% | |
| 111.95 | 1 | < 0.1% | |
| 109.9 | 1 | < 0.1% |
avg_stock_count_3m
Highly correlated
This variable is highly correlated with avg_stock_count_1m and should be ignored for analysis
| Correlation | 0.9902316431 |
|---|
avg_stock_count_6m
Highly correlated
This variable is highly correlated with avg_stock_count_3m and should be ignored for analysis
| Correlation | 0.9945684363 |
|---|
buy_order
Numeric
| Distinct count | 10 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.1789914731 |
|---|---|
| Minimum | 0 |
| Maximum | 9 |
| Zeros (%) | 88.0% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 9 |
| Range | 9 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.5852430512 |
|---|---|
| Coef of variation | 3.269670008 |
| Kurtosis | 34.92799677 |
| Mean | 0.1789914731 |
| MAD | 0.3148797364 |
| Skewness | 4.92497328 |
| Sum | 2435 |
| Variance | 0.342509429 |
| Memory size | 106.4 KiB |
| Value | Count | Frequency (%) | |
| 0 | 11966 | 88.0% | |
| 1 | 1146 | 8.4% | |
| 2 | 317 | 2.3% | |
| 3 | 99 | 0.7% | |
| 4 | 47 | 0.3% | |
| 5 | 15 | 0.1% | |
| 6 | 9 | 0.1% | |
| 9 | 2 | < 0.1% | |
| 8 | 2 | < 0.1% | |
| 7 | 1 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 11966 | 88.0% | |
| 1 | 1146 | 8.4% | |
| 2 | 317 | 2.3% | |
| 3 | 99 | 0.7% | |
| 4 | 47 | 0.3% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 9 | 2 | < 0.1% | |
| 8 | 2 | < 0.1% | |
| 7 | 1 | < 0.1% | |
| 6 | 9 | 0.1% | |
| 5 | 15 | 0.1% |
buy_order_1m
Numeric
| Distinct count | 82 |
|---|---|
| Unique (%) | 0.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.877389003 |
|---|---|
| Minimum | 0 |
| Maximum | 258 |
| Zeros (%) | 58.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 3 |
| 95-th percentile | 14 |
| Maximum | 258 |
| Range | 258 |
| Interquartile range | 3 |
Descriptive statistics
| Standard deviation | 7.309659159 |
|---|---|
| Coef of variation | 2.540379195 |
| Kurtosis | 158.3257298 |
| Mean | 2.877389003 |
| MAD | 3.8247429 |
| Skewness | 8.328488898 |
| Sum | 39144 |
| Variance | 53.43111702 |
| Memory size | 106.4 KiB |
| Value | Count | Frequency (%) | |
| 0 | 7919 | 58.2% | |
| 1 | 1354 | 10.0% | |
| 2 | 784 | 5.8% | |
| 3 | 580 | 4.3% | |
| 4 | 490 | 3.6% | |
| 5 | 361 | 2.7% | |
| 6 | 268 | 2.0% | |
| 7 | 257 | 1.9% | |
| 8 | 207 | 1.5% | |
| 9 | 170 | 1.2% | |
| Other values (72) | 1214 | 8.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 7919 | 58.2% | |
| 1 | 1354 | 10.0% | |
| 2 | 784 | 5.8% | |
| 3 | 580 | 4.3% | |
| 4 | 490 | 3.6% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 258 | 1 | < 0.1% | |
| 130 | 1 | < 0.1% | |
| 128 | 1 | < 0.1% | |
| 127 | 1 | < 0.1% | |
| 109 | 1 | < 0.1% |
buy_order_3m
Numeric
| Distinct count | 180 |
|---|---|
| Unique (%) | 1.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 9.183990003 |
|---|---|
| Minimum | 0 |
| Maximum | 793 |
| Zeros (%) | 43.7% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 1 |
| Q3 | 9 |
| 95-th percentile | 42 |
| Maximum | 793 |
| Range | 793 |
| Interquartile range | 9 |
Descriptive statistics
| Standard deviation | 22.76311838 |
|---|---|
| Coef of variation | 2.478565239 |
| Kurtosis | 187.4377834 |
| Mean | 9.183990003 |
| MAD | 11.61070418 |
| Skewness | 9.475589842 |
| Sum | 124939 |
| Variance | 518.1595584 |
| Memory size | 106.4 KiB |
| Value | Count | Frequency (%) | |
| 0 | 5945 | 43.7% | |
| 1 | 1435 | 10.5% | |
| 2 | 645 | 4.7% | |
| 3 | 428 | 3.1% | |
| 4 | 397 | 2.9% | |
| 5 | 334 | 2.5% | |
| 6 | 300 | 2.2% | |
| 7 | 285 | 2.1% | |
| 8 | 237 | 1.7% | |
| 9 | 212 | 1.6% | |
| Other values (170) | 3386 | 24.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 5945 | 43.7% | |
| 1 | 1435 | 10.5% | |
| 2 | 645 | 4.7% | |
| 3 | 428 | 3.1% | |
| 4 | 397 | 2.9% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 793 | 1 | < 0.1% | |
| 534 | 1 | < 0.1% | |
| 474 | 1 | < 0.1% | |
| 425 | 1 | < 0.1% | |
| 408 | 1 | < 0.1% |
buy_order_6m
Highly correlated
This variable is highly correlated with buy_order_3m and should be ignored for analysis
| Correlation | 0.9541051671 |
|---|
buy_orders_1m_3m_per
Numeric
| Distinct count | 711 |
|---|---|
| Unique (%) | 5.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.6373202265 |
|---|---|
| Minimum | 0 |
| Maximum | 1 |
| Zeros (%) | 14.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.2307692308 |
| Median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range | 0.7692307692 |
Descriptive statistics
| Standard deviation | 0.4105736767 |
|---|---|
| Coef of variation | 0.644218808 |
| Kurtosis | -1.556919134 |
| Mean | 0.6373202265 |
| MAD | 0.3867238175 |
| Skewness | -0.4316511474 |
| Sum | 8670.104362 |
| Variance | 0.168570744 |
| Memory size | 106.4 KiB |
| Value | Count | Frequency (%) | |
| 1 | 7124 | 52.4% | |
| 0 | 1974 | 14.5% | |
| 0.5 | 330 | 2.4% | |
| 0.3333333333 | 274 | 2.0% | |
| 0.25 | 205 | 1.5% | |
| 0.2 | 171 | 1.3% | |
| 0.6666666667 | 120 | 0.9% | |
| 0.1666666667 | 116 | 0.9% | |
| 0.2857142857 | 103 | 0.8% | |
| 0.4 | 96 | 0.7% | |
| Other values (701) | 3091 | 22.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1974 | 14.5% | |
| 0.01923076923 | 1 | < 0.1% | |
| 0.02040816327 | 1 | < 0.1% | |
| 0.02222222222 | 1 | < 0.1% | |
| 0.0243902439 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1 | 7124 | 52.4% | |
| 0.9838709677 | 1 | < 0.1% | |
| 0.9705882353 | 1 | < 0.1% | |
| 0.9666666667 | 1 | < 0.1% | |
| 0.9545454545 | 1 | < 0.1% |
buy_orders_1m_6m_per
Numeric
| Distinct count | 967 |
|---|---|
| Unique (%) | 7.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.5155653086 |
|---|---|
| Minimum | 0 |
| Maximum | 1 |
| Zeros (%) | 22.8% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.05263157895 |
| Median | 0.3888888889 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range | 0.9473684211 |
Descriptive statistics
| Standard deviation | 0.4413275791 |
|---|---|
| Coef of variation | 0.856007128 |
| Kurtosis | -1.82370802 |
| Mean | 0.5155653086 |
| MAD | 0.4222348346 |
| Skewness | 0.05300237862 |
| Sum | 7013.750458 |
| Variance | 0.1947700321 |
| Memory size | 106.4 KiB |
| Value | Count | Frequency (%) | |
| 1 | 5756 | 42.3% | |
| 0 | 3104 | 22.8% | |
| 0.5 | 256 | 1.9% | |
| 0.3333333333 | 195 | 1.4% | |
| 0.25 | 161 | 1.2% | |
| 0.2 | 127 | 0.9% | |
| 0.1666666667 | 114 | 0.8% | |
| 0.125 | 104 | 0.8% | |
| 0.1428571429 | 100 | 0.7% | |
| 0.1111111111 | 98 | 0.7% | |
| Other values (957) | 3589 | 26.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 3104 | 22.8% | |
| 0.008 | 1 | < 0.1% | |
| 0.01265822785 | 1 | < 0.1% | |
| 0.01333333333 | 1 | < 0.1% | |
| 0.01351351351 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1 | 5756 | 42.3% | |
| 0.9838709677 | 1 | < 0.1% | |
| 0.9705882353 | 1 | < 0.1% | |
| 0.9666666667 | 1 | < 0.1% | |
| 0.9545454545 | 1 | < 0.1% |
cash_vs_1m
Numeric
| Distinct count | 4405 |
|---|---|
| Unique (%) | 32.4% |
| Missing (%) | 15.7% |
| Missing (n) | 2142 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 726967.6534 |
|---|---|
| Minimum | -7.584724702e+10 |
| Maximum | 5.157112255e+10 |
| Zeros (%) | 51.0% |
Quantile statistics
| Minimum | -7.584724702e+10 |
|---|---|
| 5-th percentile | -25941612.48 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 12457042.61 |
| Maximum | 5.157112255e+10 |
| Range | 1.274183696e+11 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 1012981537 |
|---|---|
| Coef of variation | 1393.434127 |
| Kurtosis | 3541.586039 |
| Mean | 726967.6534 |
| MAD | 37767879.09 |
| Skewness | -18.62859592 |
| Sum | 8332503244 |
| Variance | 1.026131595e+18 |
| Memory size | 106.4 KiB |
| Value | Count | Frequency (%) | |
| 0 | 6937 | 51.0% | |
| 3230 | 8 | 0.1% | |
| 19380 | 6 | < 0.1% | |
| 193800 | 6 | < 0.1% | |
| 161500 | 6 | < 0.1% | |
| 9500 | 5 | < 0.1% | |
| 475 | 5 | < 0.1% | |
| 16150 | 5 | < 0.1% | |
| 5776 | 4 | < 0.1% | |
| 47500 | 4 | < 0.1% | |
| Other values (4394) | 4476 | 32.9% | |
| (Missing) | 2142 | 15.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -7.584724702e+10 | 1 | < 0.1% | |
| -1.415609146e+10 | 1 | < 0.1% | |
| -1.355085659e+10 | 1 | < 0.1% | |
| -5878022982 | 1 | < 0.1% | |
| -4415000000 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 5.157112255e+10 | 1 | < 0.1% | |
| 3.247732373e+10 | 1 | < 0.1% | |
| 2.927193892e+10 | 1 | < 0.1% | |
| 2.84647159e+10 | 1 | < 0.1% | |
| 8340618029 | 1 | < 0.1% |
cash_vs_3m
Highly correlated
This variable is highly correlated with cash_vs_1m and should be ignored for analysis
| Correlation | 0.9177938753 |
|---|
cash_vs_6m
Highly correlated
This variable is highly correlated with cash_vs_3m and should be ignored for analysis
| Correlation | 0.9191843439 |
|---|
CashBalance
Highly correlated
This variable is highly correlated with cash_vs_6m and should be ignored for analysis
| Correlation | 0.9575212639 |
|---|
Gender
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.4% |
| Missing (n) | 59 |
| M | |
|---|---|
| F | |
| O | 7 |
| (Missing) | 59 |
| Value | Count | Frequency (%) | |
| M | 7553 | 55.5% | |
| F | 5985 | 44.0% | |
| O | 7 | 0.1% | |
| (Missing) | 59 | 0.4% |
| Max length | 4 |
|---|---|
| Mean length | 1.013010879 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
loan_vs_1m
Numeric
| Distinct count | 2956 |
|---|---|
| Unique (%) | 21.7% |
| Missing (%) | 75.2% |
| Missing (n) | 10235 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 70477019.99 |
|---|---|
| Minimum | -3.389330217e+10 |
| Maximum | 2.273403394e+10 |
| Zeros (%) | 3.0% |
Quantile statistics
| Minimum | -3.389330217e+10 |
|---|---|
| 5-th percentile | -171073408.6 |
| Q1 | -8086008.75 |
| Median | 0 |
| Q3 | 39859560 |
| 95-th percentile | 463757292 |
| Maximum | 2.273403394e+10 |
| Range | 5.662733611e+10 |
| Interquartile range | 47945568.75 |
Descriptive statistics
| Standard deviation | 1138549436 |
|---|---|
| Coef of variation | 16.1549032 |
| Kurtosis | 343.0113857 |
| Mean | 70477019.99 |
| MAD | 241497658.9 |
| Skewness | -4.31810607 |
| Sum | 2.374370803e+11 |
| Variance | 1.296294818e+18 |
| Memory size | 106.4 KiB |
| Value | Count | Frequency (%) | |
| 0 | 406 | 3.0% | |
| -2375000 | 2 | < 0.1% | |
| -13326.4 | 2 | < 0.1% | |
| 1479363.636 | 2 | < 0.1% | |
| -4275000 | 2 | < 0.1% | |
| -20548500 | 2 | < 0.1% | |
| -760000 | 2 | < 0.1% | |
| -6750000000 | 2 | < 0.1% | |
| -50000 | 2 | < 0.1% | |
| -361667.7 | 2 | < 0.1% | |
| Other values (2945) | 2945 | 21.6% | |
| (Missing) | 10235 | 75.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -3.389330217e+10 | 1 | < 0.1% | |
| -1.866150068e+10 | 1 | < 0.1% | |
| -1.319341883e+10 | 1 | < 0.1% | |
| -6750000000 | 2 | < 0.1% | |
| -6009409406 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2.273403394e+10 | 1 | < 0.1% | |
| 1.478023073e+10 | 1 | < 0.1% | |
| 1.44956863e+10 | 1 | < 0.1% | |
| 1.382210686e+10 | 1 | < 0.1% | |
| 1.347580698e+10 | 1 | < 0.1% |
loan_vs_3m
Numeric
| Distinct count | 3260 |
|---|---|
| Unique (%) | 24.0% |
| Missing (%) | 75.2% |
| Missing (n) | 10235 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 111324959.6 |
|---|---|
| Minimum | -5.988427975e+10 |
| Maximum | 3.274134179e+10 |
| Zeros (%) | 0.8% |
Quantile statistics
| Minimum | -5.988427975e+10 |
|---|---|
| 5-th percentile | -241272083.1 |
| Q1 | -16208625 |
| Median | 2250306.262 |
| Q3 | 70211272.04 |
| 95-th percentile | 742796138.9 |
| Maximum | 3.274134179e+10 |
| Range | 9.262562155e+10 |
| Interquartile range | 86419897.04 |
Descriptive statistics
| Standard deviation | 2190818630 |
|---|---|
| Coef of variation | 19.67949181 |
| Kurtosis | 412.1779 |
| Mean | 111324959.6 |
| MAD | 394694935 |
| Skewness | -11.44564399 |
| Sum | 3.750537888e+11 |
| Variance | 4.79968627e+18 |
| Memory size | 106.4 KiB |
| Value | Count | Frequency (%) | |
| 0 | 111 | 0.8% | |
| -703481.4545 | 1 | < 0.1% | |
| 3195643.636 | 1 | < 0.1% | |
| -71296971.29 | 1 | < 0.1% | |
| 781236417.2 | 1 | < 0.1% | |
| -44647550.16 | 1 | < 0.1% | |
| -88894722.33 | 1 | < 0.1% | |
| 313199066.5 | 1 | < 0.1% | |
| 11331673.52 | 1 | < 0.1% | |
| 2728711.429 | 1 | < 0.1% | |
| Other values (3249) | 3249 | 23.9% | |
| (Missing) | 10235 | 75.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -5.988427975e+10 | 1 | < 0.1% | |
| -5.798337541e+10 | 1 | < 0.1% | |
| -4.68623551e+10 | 1 | < 0.1% | |
| -1.311579666e+10 | 1 | < 0.1% | |
| -1.310427327e+10 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 3.274134179e+10 | 1 | < 0.1% | |
| 3.05322242e+10 | 1 | < 0.1% | |
| 2.379214094e+10 | 1 | < 0.1% | |
| 1.792668322e+10 | 1 | < 0.1% | |
| 1.777537086e+10 | 1 | < 0.1% |
loan_vs_6m
Highly correlated
This variable is highly correlated with loan_vs_3m and should be ignored for analysis
| Correlation | 0.9634403754 |
|---|
LoanBalance
Highly correlated
This variable is highly correlated with avg_loan_3m and should be ignored for analysis
| Correlation | 0.9520490662 |
|---|
main_account
Categorical, Unique
| First 5 values |
|---|
| 0001898ab3584ff6a99ec11ffcb1f09c |
| 00029e5f2da54460a1d7dd1a491d991f |
| 00057207ba05405a911387bbcb3861bc |
| 000a64c8a9d5465eba885a561e1b0ca9 |
| 001d09340ebb4b95af55684d8635a819 |
| Last 5 values |
|---|
| ffe8f9741d61422eac913ca1fce1c95f |
| ffef4d87ab1f4afc96255d56b1eec790 |
| fff283aac89f4f82ab8b931dd9a9e41e |
| fff942970c8d4976993aa8e949f2c228 |
| fff95069a1554792bfe041e2f7b184bc |
First 5 values
| Value | Count | Frequency (%) | |
| 0001898ab3584ff6a99ec11ffcb1f09c | 1 | < 0.1% | |
| 00029e5f2da54460a1d7dd1a491d991f | 1 | < 0.1% | |
| 00057207ba05405a911387bbcb3861bc | 1 | < 0.1% | |
| 000a64c8a9d5465eba885a561e1b0ca9 | 1 | < 0.1% | |
| 001d09340ebb4b95af55684d8635a819 | 1 | < 0.1% |
Last 5 values
| Value | Count | Frequency (%) | |
| fff95069a1554792bfe041e2f7b184bc | 1 | < 0.1% | |
| fff942970c8d4976993aa8e949f2c228 | 1 | < 0.1% | |
| fff283aac89f4f82ab8b931dd9a9e41e | 1 | < 0.1% | |
| ffef4d87ab1f4afc96255d56b1eec790 | 1 | < 0.1% | |
| ffe8f9741d61422eac913ca1fce1c95f | 1 | < 0.1% |
num_oder
Numeric
| Distinct count | 14 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.3024845634 |
|---|---|
| Minimum | 0 |
| Maximum | 27 |
| Zeros (%) | 83.7% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 2 |
| Maximum | 27 |
| Range | 27 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.9132913055 |
|---|---|
| Coef of variation | 3.019298887 |
| Kurtosis | 79.3953906 |
| Mean | 0.3024845634 |
| MAD | 0.5062903196 |
| Skewness | 6.025545905 |
| Sum | 4115 |
| Variance | 0.8341010087 |
| Memory size | 106.4 KiB |
| Value | Count | Frequency (%) | |
| 0 | 11385 | 83.7% | |
| 1 | 1287 | 9.5% | |
| 2 | 483 | 3.6% | |
| 3 | 223 | 1.6% | |
| 4 | 107 | 0.8% | |
| 5 | 53 | 0.4% | |
| 6 | 29 | 0.2% | |
| 7 | 13 | 0.1% | |
| 8 | 12 | 0.1% | |
| 10 | 4 | < 0.1% | |
| Other values (4) | 8 | 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 11385 | 83.7% | |
| 1 | 1287 | 9.5% | |
| 2 | 483 | 3.6% | |
| 3 | 223 | 1.6% | |
| 4 | 107 | 0.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 27 | 1 | < 0.1% | |
| 12 | 1 | < 0.1% | |
| 11 | 3 | < 0.1% | |
| 10 | 4 | < 0.1% | |
| 9 | 3 | < 0.1% |
port_value_vs_1m
Numeric
| Distinct count | 11790 |
|---|---|
| Unique (%) | 86.7% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 144910865.6 |
|---|---|
| Minimum | -9.830860829e+10 |
| Maximum | 3.706249945e+11 |
| Zeros (%) | 2.4% |
Quantile statistics
| Minimum | -9.830860829e+10 |
|---|---|
| 5-th percentile | -60083345 |
| Q1 | -160367.5 |
| Median | 16442.5 |
| Q3 | 6195187.5 |
| 95-th percentile | 182180999.7 |
| Maximum | 3.706249945e+11 |
| Range | 4.689336028e+11 |
| Interquartile range | 6355555 |
Descriptive statistics
| Standard deviation | 4228565006 |
|---|---|
| Coef of variation | 29.18045509 |
| Kurtosis | 4542.084143 |
| Mean | 144910865.6 |
| MAD | 337269872.7 |
| Skewness | 56.33449157 |
| Sum | 1.971367416e+12 |
| Variance | 1.788076201e+19 |
| Memory size | 106.4 KiB |
| Value | Count | Frequency (%) | |
| 0 | 333 | 2.4% | |
| 15275 | 67 | 0.5% | |
| 9400 | 49 | 0.4% | |
| 3525 | 45 | 0.3% | |
| 2350 | 42 | 0.3% | |
| 1335 | 34 | 0.2% | |
| 8225 | 33 | 0.2% | |
| 12925 | 32 | 0.2% | |
| -12765 | 31 | 0.2% | |
| 19333450 | 25 | 0.2% | |
| Other values (11780) | 12913 | 94.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -9.830860829e+10 | 1 | < 0.1% | |
| -3.097203787e+10 | 1 | < 0.1% | |
| -2.848382964e+10 | 1 | < 0.1% | |
| -1.856616175e+10 | 1 | < 0.1% | |
| -1.40365349e+10 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 3.706249945e+11 | 1 | < 0.1% | |
| 1.335317752e+11 | 1 | < 0.1% | |
| 1.1178384e+11 | 1 | < 0.1% | |
| 9.737715978e+10 | 1 | < 0.1% | |
| 9.70063935e+10 | 1 | < 0.1% |
port_value_vs_3m
Numeric
| Distinct count | 12348 |
|---|---|
| Unique (%) | 90.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 160652168.3 |
|---|---|
| Minimum | -8.38775852e+11 |
| Maximum | 8.72527666e+11 |
| Zeros (%) | 1.9% |
Quantile statistics
| Minimum | -8.38775852e+11 |
|---|---|
| 5-th percentile | -126889800.1 |
| Q1 | -1357746.154 |
| Median | 4624.230769 |
| Q3 | 10598760.38 |
| 95-th percentile | 317715156.2 |
| Maximum | 8.72527666e+11 |
| Range | 1.711303518e+12 |
| Interquartile range | 11956506.54 |
Descriptive statistics
| Standard deviation | 1.165843025e+10 |
|---|---|
| Coef of variation | 72.56939248 |
| Kurtosis | 4322.562871 |
| Mean | 160652168.3 |
| MAD | 621804649.2 |
| Skewness | 5.499470041 |
| Sum | 2.185512097e+12 |
| Variance | 1.359189959e+20 |
| Memory size | 106.4 KiB |
| Value | Count | Frequency (%) | |
| 0 | 257 | 1.9% | |
| 29210 | 67 | 0.5% | |
| 17975.38462 | 45 | 0.3% | |
| 6740.769231 | 43 | 0.3% | |
| 4493.846154 | 38 | 0.3% | |
| -950.7692308 | 34 | 0.2% | |
| 15728.46154 | 32 | 0.2% | |
| 24716.15385 | 32 | 0.2% | |
| -3221.538462 | 31 | 0.2% | |
| 36970872.31 | 25 | 0.2% | |
| Other values (12338) | 13000 | 95.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -8.38775852e+11 | 1 | < 0.1% | |
| -1.794365538e+11 | 1 | < 0.1% | |
| -8.827642019e+10 | 1 | < 0.1% | |
| -8.01519796e+10 | 1 | < 0.1% | |
| -7.716681874e+10 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 8.72527666e+11 | 1 | < 0.1% | |
| 2.5534947e+11 | 1 | < 0.1% | |
| 2.139304086e+11 | 1 | < 0.1% | |
| 1.8775431e+11 | 1 | < 0.1% | |
| 1.874648158e+11 | 1 | < 0.1% |
port_value_vs_6m
Highly correlated
This variable is highly correlated with port_value_vs_3m and should be ignored for analysis
| Correlation | 0.9076132457 |
|---|
portfolio_value
Highly correlated
This variable is highly correlated with avg_portfolio_value_6m and should be ignored for analysis
| Correlation | 0.9673778626 |
|---|
profit
Numeric
| Distinct count | 1007 |
|---|---|
| Unique (%) | 7.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 117809.4624 |
|---|---|
| Minimum | -349347980 |
| Maximum | 615615000 |
| Zeros (%) | 91.5% |
Quantile statistics
| Minimum | -349347980 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 615615000 |
| Range | 964962980 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 9863835.39 |
|---|---|
| Coef of variation | 83.72702152 |
| Kurtosis | 1946.161602 |
| Mean | 117809.4624 |
| MAD | 763559.9918 |
| Skewness | 25.84513152 |
| Sum | 1602679926 |
| Variance | 9.729524861e+13 |
| Memory size | 106.4 KiB |
| Value | Count | Frequency (%) | |
| 0 | 12447 | 91.5% | |
| 250000 | 7 | 0.1% | |
| 60000 | 5 | < 0.1% | |
| -80000 | 5 | < 0.1% | |
| -1200000 | 4 | < 0.1% | |
| -200000 | 4 | < 0.1% | |
| 360000 | 4 | < 0.1% | |
| 50000 | 4 | < 0.1% | |
| 800000 | 4 | < 0.1% | |
| -30000 | 4 | < 0.1% | |
| Other values (997) | 1116 | 8.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -349347980 | 1 | < 0.1% | |
| -318174550 | 1 | < 0.1% | |
| -127228000 | 1 | < 0.1% | |
| -112980000 | 1 | < 0.1% | |
| -102435000 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 615615000 | 1 | < 0.1% | |
| 519606400 | 1 | < 0.1% | |
| 216000000 | 1 | < 0.1% | |
| 199879920 | 1 | < 0.1% | |
| 194221500 | 1 | < 0.1% |
profit_1m
Numeric
| Distinct count | 4275 |
|---|---|
| Unique (%) | 31.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | -4321903.938 |
|---|---|
| Minimum | -1.710295648e+10 |
| Maximum | 1.658551664e+10 |
| Zeros (%) | 65.4% |
Quantile statistics
| Minimum | -1.710295648e+10 |
|---|---|
| 5-th percentile | -20455944.5 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 4620706.25 |
| Maximum | 1.658551664e+10 |
| Range | 3.368847312e+10 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 228883856.7 |
|---|---|
| Coef of variation | -52.95903379 |
| Kurtosis | 4366.427447 |
| Mean | -4321903.938 |
| MAD | 16537083.04 |
| Skewness | -3.018362292 |
| Sum | -5.879518117e+10 |
| Variance | 5.238781985e+16 |
| Memory size | 106.4 KiB |
| Value | Count | Frequency (%) | |
| 0 | 8893 | 65.4% | |
| 50000 | 10 | 0.1% | |
| -200000 | 8 | 0.1% | |
| 6000 | 7 | 0.1% | |
| 100000 | 7 | 0.1% | |
| -900000 | 6 | < 0.1% | |
| -300000 | 6 | < 0.1% | |
| -3500000 | 6 | < 0.1% | |
| -170000 | 6 | < 0.1% | |
| -350000 | 6 | < 0.1% | |
| Other values (4265) | 4649 | 34.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -1.710295648e+10 | 1 | < 0.1% | |
| -4795443160 | 1 | < 0.1% | |
| -4101002000 | 1 | < 0.1% | |
| -2265000000 | 1 | < 0.1% | |
| -2030072000 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1.658551664e+10 | 1 | < 0.1% | |
| 5395040000 | 1 | < 0.1% | |
| 2401551060 | 1 | < 0.1% | |
| 1712923410 | 1 | < 0.1% | |
| 1589843720 | 1 | < 0.1% |
profit_3m
Numeric
| Distinct count | 5926 |
|---|---|
| Unique (%) | 43.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 36171208.98 |
|---|---|
| Minimum | -1.5608975e+10 |
| Maximum | 5.394120453e+11 |
| Zeros (%) | 53.8% |
Quantile statistics
| Minimum | -1.5608975e+10 |
|---|---|
| 5-th percentile | -46098213 |
| Q1 | -16825 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 20831631 |
| Maximum | 5.394120453e+11 |
| Range | 5.550210203e+11 |
| Interquartile range | 16825 |
Descriptive statistics
| Standard deviation | 4638865111 |
|---|---|
| Coef of variation | 128.2474443 |
| Kurtosis | 13439.42418 |
| Mean | 36171208.98 |
| MAD | 102259660.2 |
| Skewness | 115.58013 |
| Sum | 4.92073127e+11 |
| Variance | 2.151906951e+19 |
| Memory size | 106.4 KiB |
| Value | Count | Frequency (%) | |
| 0 | 7316 | 53.8% | |
| -100000 | 8 | 0.1% | |
| 150000 | 8 | 0.1% | |
| 200000 | 6 | < 0.1% | |
| 800000 | 6 | < 0.1% | |
| -200000 | 6 | < 0.1% | |
| -40000 | 6 | < 0.1% | |
| 100000 | 5 | < 0.1% | |
| 50000 | 5 | < 0.1% | |
| 300000 | 5 | < 0.1% | |
| Other values (5916) | 6233 | 45.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -1.5608975e+10 | 1 | < 0.1% | |
| -1.362708333e+10 | 1 | < 0.1% | |
| -1.12361121e+10 | 1 | < 0.1% | |
| -4950650000 | 1 | < 0.1% | |
| -4458254300 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 5.394120453e+11 | 1 | < 0.1% | |
| 1.772901048e+10 | 1 | < 0.1% | |
| 1.527245e+10 | 1 | < 0.1% | |
| 1.51568364e+10 | 1 | < 0.1% | |
| 8133764640 | 1 | < 0.1% |
profit_6m
Highly correlated
This variable is highly correlated with profit_3m and should be ignored for analysis
| Correlation | 0.9943629294 |
|---|
profit_per
Numeric
| Distinct count | 1057 |
|---|---|
| Unique (%) | 7.8% |
| Missing (%) | 91.4% |
| Missing (n) | 12437 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | -0.006972851696 |
|---|---|
| Minimum | -0.932 |
| Maximum | 0.5087719298 |
| Zeros (%) | 0.1% |
Quantile statistics
| Minimum | -0.932 |
|---|---|
| 5-th percentile | -0.1493567382 |
| Q1 | -0.03215310904 |
| Median | 0 |
| Q3 | 0.0295031947 |
| 95-th percentile | 0.1012985049 |
| Maximum | 0.5087719298 |
| Range | 1.44077193 |
| Interquartile range | 0.06165630375 |
Descriptive statistics
| Standard deviation | 0.0884352132 |
|---|---|
| Coef of variation | -12.68278992 |
| Kurtosis | 16.25935014 |
| Mean | -0.006972851696 |
| MAD | 0.05380847175 |
| Skewness | -1.298429184 |
| Sum | -8.137317929 |
| Variance | 0.007820786933 |
| Memory size | 106.4 KiB |
| Value | Count | Frequency (%) | |
| 0 | 10 | 0.1% | |
| 0.02610759494 | 10 | 0.1% | |
| -0.02071005917 | 10 | 0.1% | |
| -0.0313253012 | 8 | 0.1% | |
| 0.03202846975 | 6 | < 0.1% | |
| 0.0623556582 | 6 | < 0.1% | |
| -0.0293255132 | 6 | < 0.1% | |
| 0.1052631579 | 4 | < 0.1% | |
| 0.02206461781 | 4 | < 0.1% | |
| 0.03401360544 | 3 | < 0.1% | |
| Other values (1046) | 1100 | 8.1% | |
| (Missing) | 12437 | 91.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -0.932 | 1 | < 0.1% | |
| -0.5227068664 | 1 | < 0.1% | |
| -0.5188764514 | 1 | < 0.1% | |
| -0.4219979136 | 1 | < 0.1% | |
| -0.4193548387 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 0.5087719298 | 1 | < 0.1% | |
| 0.4194101225 | 1 | < 0.1% | |
| 0.3996586198 | 1 | < 0.1% | |
| 0.3930348259 | 1 | < 0.1% | |
| 0.3898641614 | 1 | < 0.1% |
region
Categorical
| Distinct count | 71 |
|---|---|
| Unique (%) | 0.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| HN | |
|---|---|
| DVSN | |
| HCM | |
| Other values (68) |
| Value | Count | Frequency (%) | |
| HN | 3940 | 29.0% | |
| DVSN | 3385 | 24.9% | |
| HCM | 1995 | 14.7% | |
| NgheAn | 246 | 1.8% | |
| DaNang | 195 | 1.4% | |
| ThanhHoa | 193 | 1.4% | |
| DongNai | 187 | 1.4% | |
| NamDinh | 168 | 1.2% | |
| BacNinh | 158 | 1.2% | |
| HaiPhong | 148 | 1.1% | |
| Other values (61) | 2989 | 22.0% |
| Max length | 10 |
|---|---|
| Mean length | 4.250882094 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
sell_order
Numeric
| Distinct count | 11 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.1234930903 |
|---|---|
| Minimum | 0 |
| Maximum | 18 |
| Zeros (%) | 91.4% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 18 |
| Range | 18 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.5023309343 |
|---|---|
| Coef of variation | 4.067684542 |
| Kurtosis | 162.5919919 |
| Mean | 0.1234930903 |
| MAD | 0.2257988185 |
| Skewness | 8.550222405 |
| Sum | 1680 |
| Variance | 0.2523363676 |
| Memory size | 106.4 KiB |
| Value | Count | Frequency (%) | |
| 0 | 12437 | 91.4% | |
| 1 | 856 | 6.3% | |
| 2 | 202 | 1.5% | |
| 3 | 64 | 0.5% | |
| 4 | 28 | 0.2% | |
| 5 | 8 | 0.1% | |
| 7 | 3 | < 0.1% | |
| 6 | 2 | < 0.1% | |
| 8 | 2 | < 0.1% | |
| 18 | 1 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 12437 | 91.4% | |
| 1 | 856 | 6.3% | |
| 2 | 202 | 1.5% | |
| 3 | 64 | 0.5% | |
| 4 | 28 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 18 | 1 | < 0.1% | |
| 9 | 1 | < 0.1% | |
| 8 | 2 | < 0.1% | |
| 7 | 3 | < 0.1% | |
| 6 | 2 | < 0.1% |
sell_order_1m
Numeric
| Distinct count | 71 |
|---|---|
| Unique (%) | 0.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.139223758 |
|---|---|
| Minimum | 0 |
| Maximum | 199 |
| Zeros (%) | 65.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 2 |
| 95-th percentile | 11 |
| Maximum | 199 |
| Range | 199 |
| Interquartile range | 2 |
Descriptive statistics
| Standard deviation | 6.141631988 |
|---|---|
| Coef of variation | 2.870962874 |
| Kurtosis | 165.7239961 |
| Mean | 2.139223758 |
| MAD | 2.999617915 |
| Skewness | 9.172206545 |
| Sum | 29102 |
| Variance | 37.71964348 |
| Memory size | 106.4 KiB |
| Value | Count | Frequency (%) | |
| 0 | 8865 | 65.2% | |
| 1 | 1167 | 8.6% | |
| 2 | 788 | 5.8% | |
| 3 | 531 | 3.9% | |
| 4 | 376 | 2.8% | |
| 5 | 293 | 2.2% | |
| 6 | 259 | 1.9% | |
| 7 | 192 | 1.4% | |
| 8 | 157 | 1.2% | |
| 9 | 141 | 1.0% | |
| Other values (61) | 835 | 6.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 8865 | 65.2% | |
| 1 | 1167 | 8.6% | |
| 2 | 788 | 5.8% | |
| 3 | 531 | 3.9% | |
| 4 | 376 | 2.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 199 | 1 | < 0.1% | |
| 157 | 1 | < 0.1% | |
| 125 | 1 | < 0.1% | |
| 115 | 1 | < 0.1% | |
| 103 | 1 | < 0.1% |
sell_order_3m
Highly correlated
This variable is highly correlated with sell_order_1m and should be ignored for analysis
| Correlation | 0.9065289845 |
|---|
sell_order_6m
Highly correlated
This variable is highly correlated with sell_order_3m and should be ignored for analysis
| Correlation | 0.9577278331 |
|---|
sell_order_gain
Numeric
| Distinct count | 7 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.06093795942 |
|---|---|
| Minimum | 0 |
| Maximum | 7 |
| Zeros (%) | 95.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 7 |
| Range | 7 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.3065702678 |
|---|---|
| Coef of variation | 5.030858773 |
| Kurtosis | 77.7788638 |
| Mean | 0.06093795942 |
| MAD | 0.1159630913 |
| Skewness | 7.267902874 |
| Sum | 829 |
| Variance | 0.09398532909 |
| Memory size | 106.4 KiB |
| Value | Count | Frequency (%) | |
| 0 | 12944 | 95.1% | |
| 1 | 542 | 4.0% | |
| 2 | 86 | 0.6% | |
| 3 | 21 | 0.2% | |
| 5 | 5 | < 0.1% | |
| 4 | 5 | < 0.1% | |
| 7 | 1 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 12944 | 95.1% | |
| 1 | 542 | 4.0% | |
| 2 | 86 | 0.6% | |
| 3 | 21 | 0.2% | |
| 4 | 5 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 7 | 1 | < 0.1% | |
| 5 | 5 | < 0.1% | |
| 4 | 5 | < 0.1% | |
| 3 | 21 | 0.2% | |
| 2 | 86 | 0.6% |
sell_order_loss
Numeric
| Distinct count | 8 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.06057042046 |
|---|---|
| Minimum | 0 |
| Maximum | 11 |
| Zeros (%) | 95.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 11 |
| Range | 11 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.3079588229 |
|---|---|
| Coef of variation | 5.084310469 |
| Kurtosis | 164.8590216 |
| Mean | 0.06057042046 |
| MAD | 0.1152458662 |
| Skewness | 8.923036774 |
| Sum | 824 |
| Variance | 0.09483863659 |
| Memory size | 106.4 KiB |
| Value | Count | Frequency (%) | |
| 0 | 12942 | 95.1% | |
| 1 | 546 | 4.0% | |
| 2 | 88 | 0.6% | |
| 3 | 20 | 0.1% | |
| 4 | 5 | < 0.1% | |
| 6 | 1 | < 0.1% | |
| 5 | 1 | < 0.1% | |
| 11 | 1 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 12942 | 95.1% | |
| 1 | 546 | 4.0% | |
| 2 | 88 | 0.6% | |
| 3 | 20 | 0.1% | |
| 4 | 5 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 11 | 1 | < 0.1% | |
| 6 | 1 | < 0.1% | |
| 5 | 1 | < 0.1% | |
| 4 | 5 | < 0.1% | |
| 3 | 20 | 0.1% |
sell_orders_1m_3m_per
Numeric
| Distinct count | 566 |
|---|---|
| Unique (%) | 4.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.701648483 |
|---|---|
| Minimum | 0 |
| Maximum | 1 |
| Zeros (%) | 11.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.3181818182 |
| Median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range | 0.6818181818 |
Descriptive statistics
| Standard deviation | 0.3928197584 |
|---|---|
| Coef of variation | 0.559852644 |
| Kurtosis | -1.177668115 |
| Mean | 0.701648483 |
| MAD | 0.360876928 |
| Skewness | -0.7428339894 |
| Sum | 9545.225963 |
| Variance | 0.1543073626 |
| Memory size | 106.4 KiB |
| Value | Count | Frequency (%) | |
| 1 | 8142 | 59.9% | |
| 0 | 1568 | 11.5% | |
| 0.5 | 346 | 2.5% | |
| 0.3333333333 | 295 | 2.2% | |
| 0.25 | 179 | 1.3% | |
| 0.6666666667 | 148 | 1.1% | |
| 0.2 | 130 | 1.0% | |
| 0.1666666667 | 100 | 0.7% | |
| 0.4 | 89 | 0.7% | |
| 0.75 | 81 | 0.6% | |
| Other values (556) | 2526 | 18.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1568 | 11.5% | |
| 0.01298701299 | 1 | < 0.1% | |
| 0.01724137931 | 1 | < 0.1% | |
| 0.02702702703 | 1 | < 0.1% | |
| 0.02777777778 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1 | 8142 | 59.9% | |
| 0.9782608696 | 1 | < 0.1% | |
| 0.962962963 | 1 | < 0.1% | |
| 0.9523809524 | 1 | < 0.1% | |
| 0.9375 | 1 | < 0.1% |
sell_orders_1m_6m_per
Numeric
| Distinct count | 785 |
|---|---|
| Unique (%) | 5.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.6163211648 |
|---|---|
| Minimum | 0 |
| Maximum | 1 |
| Zeros (%) | 16.9% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.1363636364 |
| Median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range | 0.8636363636 |
Descriptive statistics
| Standard deviation | 0.434040184 |
|---|---|
| Coef of variation | 0.7042435159 |
| Kurtosis | -1.702532803 |
| Mean | 0.6163211648 |
| MAD | 0.4155169174 |
| Skewness | -0.3702163563 |
| Sum | 8384.433126 |
| Variance | 0.1883908813 |
| Memory size | 106.4 KiB |
| Value | Count | Frequency (%) | |
| 1 | 7249 | 53.3% | |
| 0 | 2299 | 16.9% | |
| 0.5 | 223 | 1.6% | |
| 0.3333333333 | 189 | 1.4% | |
| 0.2 | 166 | 1.2% | |
| 0.25 | 147 | 1.1% | |
| 0.1666666667 | 107 | 0.8% | |
| 0.6666666667 | 106 | 0.8% | |
| 0.1428571429 | 91 | 0.7% | |
| 0.4 | 75 | 0.6% | |
| Other values (775) | 2952 | 21.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 2299 | 16.9% | |
| 0.007246376812 | 1 | < 0.1% | |
| 0.008064516129 | 1 | < 0.1% | |
| 0.01063829787 | 1 | < 0.1% | |
| 0.01515151515 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1 | 7249 | 53.3% | |
| 0.9782608696 | 1 | < 0.1% | |
| 0.9701492537 | 1 | < 0.1% | |
| 0.962962963 | 1 | < 0.1% | |
| 0.9523809524 | 1 | < 0.1% |
stock_count
Highly correlated
This variable is highly correlated with avg_stock_count_6m and should be ignored for analysis
| Correlation | 0.967179082 |
|---|
stock_count_vs_1m
Numeric
| Distinct count | 21 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.04483975301 |
|---|---|
| Minimum | -28 |
| Maximum | 12 |
| Zeros (%) | 80.7% |
Quantile statistics
| Minimum | -28 |
|---|---|
| 5-th percentile | -1 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 12 |
| Range | 40 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.7989300236 |
|---|---|
| Coef of variation | 17.81744925 |
| Kurtosis | 136.4729324 |
| Mean | 0.04483975301 |
| MAD | 0.3180316667 |
| Skewness | -1.760603746 |
| Sum | 610 |
| Variance | 0.6382891826 |
| Memory size | 106.4 KiB |
| Value | Count | Frequency (%) | |
| 0 | 10985 | 80.7% | |
| 1 | 965 | 7.1% | |
| -1 | 881 | 6.5% | |
| 2 | 310 | 2.3% | |
| -2 | 215 | 1.6% | |
| 3 | 109 | 0.8% | |
| -3 | 52 | 0.4% | |
| 4 | 31 | 0.2% | |
| -4 | 19 | 0.1% | |
| 5 | 12 | 0.1% | |
| Other values (11) | 25 | 0.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -28 | 1 | < 0.1% | |
| -12 | 1 | < 0.1% | |
| -7 | 2 | < 0.1% | |
| -6 | 1 | < 0.1% | |
| -5 | 3 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 12 | 1 | < 0.1% | |
| 10 | 2 | < 0.1% | |
| 9 | 3 | < 0.1% | |
| 8 | 2 | < 0.1% | |
| 7 | 3 | < 0.1% |
stock_count_vs_3m
Numeric
| Distinct count | 29 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.08431343722 |
|---|---|
| Minimum | -26 |
| Maximum | 18 |
| Zeros (%) | 73.2% |
Quantile statistics
| Minimum | -26 |
|---|---|
| 5-th percentile | -1 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 2 |
| Maximum | 18 |
| Range | 44 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 1.131645426 |
|---|---|
| Coef of variation | 13.42188698 |
| Kurtosis | 53.11587262 |
| Mean | 0.08431343722 |
| MAD | 0.5097561547 |
| Skewness | 1.242703551 |
| Sum | 1147 |
| Variance | 1.280621369 |
| Memory size | 106.4 KiB |
| Value | Count | Frequency (%) | |
| 0 | 9952 | 73.2% | |
| 1 | 1205 | 8.9% | |
| -1 | 1137 | 8.4% | |
| 2 | 449 | 3.3% | |
| -2 | 330 | 2.4% | |
| 3 | 184 | 1.4% | |
| -3 | 100 | 0.7% | |
| 4 | 80 | 0.6% | |
| -4 | 40 | 0.3% | |
| 5 | 33 | 0.2% | |
| Other values (19) | 94 | 0.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -26 | 1 | < 0.1% | |
| -15 | 1 | < 0.1% | |
| -11 | 1 | < 0.1% | |
| -10 | 2 | < 0.1% | |
| -8 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 18 | 1 | < 0.1% | |
| 16 | 1 | < 0.1% | |
| 15 | 3 | < 0.1% | |
| 14 | 2 | < 0.1% | |
| 12 | 1 | < 0.1% |
stock_count_vs_6m
Highly correlated
This variable is highly correlated with stock_count_vs_3m and should be ignored for analysis
| Correlation | 0.9005250291 |
|---|
total_buy_order_1m_3m_per
Highly correlated
This variable is highly correlated with buy_orders_1m_3m_per and should be ignored for analysis
| Correlation | 0.9809048155 |
|---|
total_buy_order_1m_6m_per
Highly correlated
This variable is highly correlated with buy_orders_1m_6m_per and should be ignored for analysis
| Correlation | 0.9834419742 |
|---|
total_buy_value
Numeric
| Distinct count | 1372 |
|---|---|
| Unique (%) | 10.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 26703523.72 |
|---|---|
| Minimum | 0 |
| Maximum | 1.7157975e+10 |
| Zeros (%) | 88.0% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 48234000 |
| Maximum | 1.7157975e+10 |
| Range | 1.7157975e+10 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 353506456.7 |
|---|---|
| Coef of variation | 13.23819509 |
| Kurtosis | 1363.955774 |
| Mean | 26703523.72 |
| MAD | 48974350.09 |
| Skewness | 33.59928488 |
| Sum | 3.632747368e+11 |
| Variance | 1.249668149e+17 |
| Memory size | 106.4 KiB |
| Value | Count | Frequency (%) | |
| 0 | 11966 | 88.0% | |
| 33100000 | 11 | 0.1% | |
| 18100000 | 10 | 0.1% | |
| 22650 | 8 | 0.1% | |
| 99300000 | 6 | < 0.1% | |
| 165500000 | 5 | < 0.1% | |
| 19700000 | 5 | < 0.1% | |
| 1810000 | 5 | < 0.1% | |
| 16550000 | 5 | < 0.1% | |
| 138033000 | 4 | < 0.1% | |
| Other values (1362) | 1579 | 11.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 11966 | 88.0% | |
| 22650 | 8 | 0.1% | |
| 28400 | 1 | < 0.1% | |
| 47000 | 1 | < 0.1% | |
| 62400 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1.7157975e+10 | 1 | < 0.1% | |
| 1.624e+10 | 1 | < 0.1% | |
| 1.518003e+10 | 1 | < 0.1% | |
| 1.46419113e+10 | 1 | < 0.1% | |
| 1.10079e+10 | 1 | < 0.1% |
total_buy_value_1m
Numeric
| Distinct count | 5410 |
|---|---|
| Unique (%) | 39.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 433664573.2 |
|---|---|
| Minimum | 0 |
| Maximum | 1.517087434e+12 |
| Zeros (%) | 58.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 58715000 |
| 95-th percentile | 1068707642 |
| Maximum | 1.517087434e+12 |
| Range | 1.517087434e+12 |
| Interquartile range | 58715000 |
Descriptive statistics
| Standard deviation | 1.320953789e+10 |
|---|---|
| Coef of variation | 30.46026515 |
| Kurtosis | 12778.54024 |
| Mean | 433664573.2 |
| MAD | 719720634.7 |
| Skewness | 111.4168123 |
| Sum | 5.899572854e+12 |
| Variance | 1.744918912e+20 |
| Memory size | 106.4 KiB |
| Value | Count | Frequency (%) | |
| 0 | 7920 | 58.2% | |
| 3590000 | 8 | 0.1% | |
| 1795000 | 7 | 0.1% | |
| 135529000 | 6 | < 0.1% | |
| 8975000 | 6 | < 0.1% | |
| 7180000 | 6 | < 0.1% | |
| 89750 | 5 | < 0.1% | |
| 22650 | 5 | < 0.1% | |
| 110470500 | 4 | < 0.1% | |
| 138033000 | 4 | < 0.1% | |
| Other values (5400) | 5633 | 41.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 7920 | 58.2% | |
| 1000 | 1 | < 0.1% | |
| 4200 | 3 | < 0.1% | |
| 6000 | 1 | < 0.1% | |
| 8400 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1.517087434e+12 | 1 | < 0.1% | |
| 1.22e+11 | 1 | < 0.1% | |
| 1.012085485e+11 | 1 | < 0.1% | |
| 6.4949831e+10 | 1 | < 0.1% | |
| 5.074104e+10 | 1 | < 0.1% |
total_buy_value_3m
Highly correlated
This variable is highly correlated with total_buy_value_1m and should be ignored for analysis
| Correlation | 0.9484353291 |
|---|
total_buy_value_6m
Numeric
| Distinct count | 8335 |
|---|---|
| Unique (%) | 61.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2441528103 |
|---|---|
| Minimum | 0 |
| Maximum | 6.754880554e+12 |
| Zeros (%) | 35.4% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 19349650 |
| Q3 | 455675125 |
| 95-th percentile | 6268552400 |
| Maximum | 6.754880554e+12 |
| Range | 6.754880554e+12 |
| Interquartile range | 455675125 |
Descriptive statistics
| Standard deviation | 6.149979756e+10 |
|---|---|
| Coef of variation | 25.18905987 |
| Kurtosis | 10758.92576 |
| Mean | 2441528103 |
| MAD | 3967073178 |
| Skewness | 99.82045008 |
| Sum | 3.321454831e+13 |
| Variance | 3.7822251e+21 |
| Memory size | 106.4 KiB |
| Value | Count | Frequency (%) | |
| 0 | 4822 | 35.4% | |
| 233200 | 32 | 0.2% | |
| 44650 | 13 | 0.1% | |
| 23600 | 12 | 0.1% | |
| 111000 | 11 | 0.1% | |
| 22200 | 11 | 0.1% | |
| 44400 | 8 | 0.1% | |
| 445200 | 7 | 0.1% | |
| 310800 | 7 | 0.1% | |
| 88800 | 6 | < 0.1% | |
| Other values (8325) | 8675 | 63.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 4822 | 35.4% | |
| 4200 | 3 | < 0.1% | |
| 6800 | 1 | < 0.1% | |
| 7000 | 1 | < 0.1% | |
| 7500 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 6.754880554e+12 | 1 | < 0.1% | |
| 1.936789406e+12 | 1 | < 0.1% | |
| 6.93925e+11 | 1 | < 0.1% | |
| 4.3857075e+11 | 1 | < 0.1% | |
| 3.967535841e+11 | 1 | < 0.1% |
total_sell_order_1m_3m_per
Highly correlated
This variable is highly correlated with sell_orders_1m_3m_per and should be ignored for analysis
| Correlation | 0.9806879469 |
|---|
total_sell_order_1m_6m_per
Highly correlated
This variable is highly correlated with sell_orders_1m_6m_per and should be ignored for analysis
| Correlation | 0.9863198197 |
|---|
total_sell_value
Numeric
| Distinct count | 1025 |
|---|---|
| Unique (%) | 7.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 14129442.43 |
|---|---|
| Minimum | 0 |
| Maximum | 1.003275e+10 |
| Zeros (%) | 91.4% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 23302000 |
| Maximum | 1.003275e+10 |
| Range | 1.003275e+10 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 156766338.6 |
|---|---|
| Coef of variation | 11.09501237 |
| Kurtosis | 1577.836066 |
| Mean | 14129442.43 |
| MAD | 26325774.17 |
| Skewness | 32.59792884 |
| Sum | 1.922169348e+11 |
| Variance | 2.457568491e+16 |
| Memory size | 106.4 KiB |
| Value | Count | Frequency (%) | |
| 0 | 12437 | 91.4% | |
| 16550000 | 6 | < 0.1% | |
| 66200000 | 5 | < 0.1% | |
| 18100000 | 5 | < 0.1% | |
| 1150000 | 4 | < 0.1% | |
| 40200000 | 4 | < 0.1% | |
| 3620000 | 4 | < 0.1% | |
| 33600000 | 4 | < 0.1% | |
| 160800000 | 4 | < 0.1% | |
| 2560000 | 4 | < 0.1% | |
| Other values (1015) | 1127 | 8.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 12437 | 91.4% | |
| 32500 | 2 | < 0.1% | |
| 62400 | 1 | < 0.1% | |
| 68000 | 1 | < 0.1% | |
| 69200 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1.003275e+10 | 1 | < 0.1% | |
| 5896074000 | 1 | < 0.1% | |
| 5009760000 | 1 | < 0.1% | |
| 4256250000 | 1 | < 0.1% | |
| 3801000000 | 1 | < 0.1% |
total_sell_value_1m
Numeric
| Distinct count | 4552 |
|---|---|
| Unique (%) | 33.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 283727916.1 |
|---|---|
| Minimum | 0 |
| Maximum | 3.91607438e+11 |
| Zeros (%) | 65.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 29303250 |
| 95-th percentile | 833674250 |
| Maximum | 3.91607438e+11 |
| Range | 3.91607438e+11 |
| Interquartile range | 29303250 |
Descriptive statistics
| Standard deviation | 3943894189 |
|---|---|
| Coef of variation | 13.90026841 |
| Kurtosis | 7223.185984 |
| Mean | 283727916.1 |
| MAD | 471326025.3 |
| Skewness | 76.04338338 |
| Sum | 3.859834571e+12 |
| Variance | 1.555430137e+19 |
| Memory size | 106.4 KiB |
| Value | Count | Frequency (%) | |
| 0 | 8867 | 65.2% | |
| 20700000 | 5 | < 0.1% | |
| 19500000 | 5 | < 0.1% | |
| 72000000 | 4 | < 0.1% | |
| 1150000 | 4 | < 0.1% | |
| 14400000 | 4 | < 0.1% | |
| 28800000 | 4 | < 0.1% | |
| 11300000 | 4 | < 0.1% | |
| 67400000 | 3 | < 0.1% | |
| 46600000 | 3 | < 0.1% | |
| Other values (4542) | 4701 | 34.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 8867 | 65.2% | |
| 1000 | 1 | < 0.1% | |
| 5500 | 1 | < 0.1% | |
| 11000 | 1 | < 0.1% | |
| 13500 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 3.91607438e+11 | 1 | < 0.1% | |
| 1.24290072e+11 | 1 | < 0.1% | |
| 7.257735e+10 | 1 | < 0.1% | |
| 7.024e+10 | 1 | < 0.1% | |
| 5.5169364e+10 | 1 | < 0.1% |
total_sell_value_3m
Highly correlated
This variable is highly correlated with profit_6m and should be ignored for analysis
| Correlation | 0.9617840254 |
|---|
total_sell_value_6m
Highly correlated
This variable is highly correlated with total_sell_value_3m and should be ignored for analysis
| Correlation | 0.988218788 |
|---|
trading_date
Constant
This variable is constant and should be ignored for analysis
| Constant value | 2019-09-30 |
|---|
trading_month
Constant
This variable is constant and should be ignored for analysis
| Constant value | 9 |
|---|
First rows
| Age | avg_cash_1m | avg_cash_3m | avg_cash_6m | avg_loan_1m | avg_loan_3m | avg_loan_6m | avg_portfolio_value_1m | avg_portfolio_value_3m | avg_portfolio_value_6m | avg_profit_per_6m | avg_stock_count_1m | avg_stock_count_3m | avg_stock_count_6m | buy_order | buy_order_1m | buy_order_3m | buy_order_6m | buy_orders_1m_3m_per | buy_orders_1m_6m_per | cash_vs_1m | cash_vs_3m | cash_vs_6m | CashBalance | Gender | loan_vs_1m | loan_vs_3m | loan_vs_6m | LoanBalance | main_account | num_oder | port_value_vs_1m | port_value_vs_3m | port_value_vs_6m | portfolio_value | profit | profit_1m | profit_3m | profit_6m | profit_per | region | sell_order | sell_order_1m | sell_order_3m | sell_order_6m | sell_order_gain | sell_order_loss | sell_orders_1m_3m_per | sell_orders_1m_6m_per | stock_count | stock_count_vs_1m | stock_count_vs_3m | stock_count_vs_6m | total_buy_order_1m_3m_per | total_buy_order_1m_6m_per | total_buy_value | total_buy_value_1m | total_buy_value_3m | total_buy_value_6m | total_sell_order_1m_3m_per | total_sell_order_1m_6m_per | total_sell_value | total_sell_value_1m | total_sell_value_3m | total_sell_value_6m | trading_date | trading_month | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 56 | 1764517.70 | 2208024.38 | 1761109.13 | nan | nan | nan | 75117895.50 | 77020380.77 | 79136573.89 | 1.61 | 9.85 | 9.26 | 9.13 | 0 | 1 | 2 | 2 | 0.50 | 0.50 | -1346537.70 | -1790044.38 | -1343129.13 | 417980.00 | F | nan | nan | nan | nan | 0001898ab3584ff6a99ec11ffcb1f09c | 0 | 927824.50 | -974660.77 | -3090853.89 | 76045720.00 | 0 | 0 | -1516300 | -1516300 | nan | HN | 0 | 0 | 2 | 2 | 0 | 0 | 0.00 | 0.00 | 10 | 0.00 | 1.00 | 1.00 | 0.93 | 0.93 | 0 | 9248000 | 9909200 | 9909200 | 0.00 | 0.00 | 0 | 0 | 8442000 | 8442000 | 2019-09-30 | 9 |
| 1 | 31 | 1303094.80 | 403252.05 | 209998.61 | 35050012.79 | 123084390.94 | 153996251.28 | 45792700.00 | 170618307.69 | 217354130.95 | -0.08 | 3.85 | 3.95 | 3.92 | 0 | 3 | 5 | 11 | 0.60 | 0.27 | -1150239.80 | -250397.05 | -57143.61 | 152855.00 | F | -23571153.79 | -111605531.94 | -142517392.28 | 11478859.00 | 00029e5f2da54460a1d7dd1a491d991f | 0 | -15452700.00 | -140278307.69 | -187014130.95 | 30340000.00 | 0 | -63556460 | -82279590 | -83728490 | nan | HN | 0 | 4 | 6 | 9 | 0 | 0 | 0.67 | 0.44 | 4 | 0.00 | 0.00 | 0.00 | 0.56 | 0.13 | 0 | 76320000 | 136390000 | 576362500 | 0.74 | 0.28 | 0 | 225433000 | 303288500 | 809958500 | 2019-09-30 | 9 |
| 2 | 37 | 23146.00 | 23143.91 | 23141.06 | nan | nan | nan | 61965.00 | 64250.77 | 67576.19 | nan | 1.00 | 1.00 | 1.00 | 0 | 0 | 0 | 0 | 1.00 | 1.00 | 0.00 | 2.09 | 4.94 | 23146.00 | M | nan | nan | nan | nan | 00057207ba05405a911387bbcb3861bc | 0 | 1335.00 | -950.77 | -4276.19 | 63300.00 | 0 | 0 | 0 | 0 | nan | ThanhHoa | 0 | 0 | 0 | 0 | 0 | 0 | 1.00 | 1.00 | 1 | 0.00 | 0.00 | 0.00 | 1.00 | 1.00 | 0 | 0 | 0 | 0 | 1.00 | 1.00 | 0 | 0 | 0 | 0 | 2019-09-30 | 9 |
| 3 | 64 | 54536987.10 | 40602026.75 | 22396767.01 | nan | nan | nan | 319849589.00 | 338784400.31 | 351875873.41 | 0.14 | 19.65 | 20.94 | 21.39 | 0 | 3 | 34 | 57 | 0.09 | 0.05 | -22570.10 | 13912390.25 | 32117649.99 | 54514417.00 | M | nan | nan | nan | nan | 000a64c8a9d5465eba885a561e1b0ca9 | 0 | 3833991.00 | -15100820.31 | -28192293.41 | 323683580.00 | 0 | -157750 | 11723760 | 14026060 | nan | DVSN | 0 | 3 | 42 | 48 | 0 | 0 | 0.07 | 0.06 | 19 | -1.00 | -2.00 | -2.00 | 0.10 | 0.06 | 0 | 7681000 | 79384500 | 126329600 | 0.06 | 0.05 | 0 | 7538000 | 122955700 | 140665700 | 2019-09-30 | 9 |
| 4 | 40 | 7768366.45 | 6756040.66 | 5297377.99 | 77494639.00 | 158683067.50 | 204127222.77 | 89628850.00 | 211257232.31 | 313340330.16 | -0.11 | 1.95 | 3.02 | 3.94 | 0 | 1 | 4 | 12 | 0.25 | 0.08 | 11562148.55 | 12574474.34 | 14033137.01 | 19330515.00 | F | nan | nan | nan | nan | 001d09340ebb4b95af55684d8635a819 | 0 | -48591100.00 | -170219482.31 | -272302580.16 | 41037750.00 | 0 | -21800000 | -22202500 | -46487500 | nan | DVSN | 0 | 1 | 10 | 16 | 0 | 0 | 0.10 | 0.06 | 2 | 0.00 | -1.00 | -2.00 | 0.01 | 0.00 | 0 | 3320750 | 248180750 | 769080750 | 0.12 | 0.10 | 0 | 91600000 | 758416100 | 882576100 | 2019-09-30 | 9 |
| 5 | 55 | 18813004.40 | 14705520.20 | 14705520.20 | nan | nan | nan | 69927750.00 | 71070666.67 | 71070666.67 | -0.08 | 3.65 | 2.98 | 2.98 | 0 | 2 | 5 | 5 | 0.40 | 0.40 | 9349654.60 | 13457138.80 | 13457138.80 | 28162659.00 | M | nan | nan | nan | nan | 0023387d6b544f53a9306495d5576cae | 0 | -11117750.00 | -12260666.67 | -12260666.67 | 58810000.00 | 0 | -5370000 | -6270000 | -6270000 | nan | HCM | 0 | 2 | 3 | 3 | 0 | 0 | 0.67 | 0.67 | 3 | -1.00 | 0.00 | 0.00 | 0.26 | 0.26 | 0 | 33600000 | 131365000 | 131365000 | 0.74 | 0.74 | 0 | 45360000 | 61060000 | 61060000 | 2019-09-30 | 9 |
| 6 | 35 | 3391323.00 | 3388776.34 | 3386420.26 | 222707013.35 | 200418954.92 | 182619916.76 | 363438520.00 | 340078321.54 | 319609795.24 | -0.17 | 3.85 | 3.75 | 3.87 | 0 | 3 | 5 | 7 | 0.60 | 0.43 | 0.00 | 2546.66 | 4902.74 | 3391323.00 | M | -7095702.35 | 15192356.08 | 32991394.24 | 215611311.00 | 00237505b9d5473186b894283286e3a7 | 0 | -1436220.00 | 21923978.46 | 42392504.76 | 362002300.00 | 0 | -29790000 | -36869640 | -44580480 | nan | BacNinh | 0 | 1 | 6 | 10 | 0 | 0 | 0.17 | 0.10 | 4 | 0.00 | 0.00 | 0.00 | 0.38 | 0.32 | 0 | 102496000 | 269820000 | 323618000 | 0.81 | 0.69 | 0 | 162000000 | 201084500 | 233894000 | 2019-09-30 | 9 |
| 7 | 31 | 275.00 | 179100.42 | 2863666.17 | 1274397504.10 | 1285594458.35 | 1975358069.89 | 2007607000.00 | 1646555750.00 | 2552118421.57 | -0.00 | 1.90 | 2.24 | 1.88 | 0 | 5 | 22 | 51 | 0.23 | 0.10 | 0.00 | -178825.42 | -2863391.17 | 275.00 | M | -42361841.10 | -53558795.35 | -743322406.89 | 1232035663.00 | 0029fdde7ec841dbbf3c5166b50ed76d | 0 | 24925000.00 | 385976250.00 | -519586421.57 | 2032532000.00 | 0 | -12580000 | -2008020 | -104984230 | nan | HCM | 0 | 2 | 16 | 33 | 0 | 0 | 0.12 | 0.06 | 1 | -1.00 | -1.00 | -1.00 | 0.09 | 0.02 | 0 | 502000000 | 5324570500 | 22525454500 | 0.07 | 0.03 | 0 | 555920000 | 7699907500 | 20326589000 | 2019-09-30 | 9 |
| 8 | 35 | 8050577.00 | 8871833.23 | 6652609.92 | nan | nan | nan | 244466550.00 | 270283135.38 | 274946692.30 | 0.24 | 7.00 | 7.48 | 7.75 | 0 | 1 | 5 | 11 | 0.20 | 0.09 | -7864875.00 | -8686131.23 | -6466907.92 | 185702.00 | M | nan | nan | nan | nan | 002c1a2e3c054378b7261e680f19b5c4 | 0 | 774450.00 | -25042135.38 | -29705692.30 | 245241000.00 | 0 | 0 | 16694500 | 16721709 | nan | HCM | 0 | 0 | 3 | 7 | 0 | 0 | 0.00 | 0.00 | 7 | 0.00 | 0.00 | -1.00 | 0.07 | 0.05 | 0 | 2610000 | 35910000 | 52730000 | 0.00 | 0.00 | 0 | 0 | 71080000 | 71533510 | 2019-09-30 | 9 |
| 9 | 35 | 88179.00 | 88549.34 | 89045.14 | nan | nan | nan | 2515660.00 | 2212118.46 | 1989566.67 | nan | 1.00 | 1.00 | 1.00 | 0 | 0 | 0 | 0 | 1.00 | 1.00 | 0.00 | -370.34 | -866.14 | 88179.00 | M | nan | nan | nan | nan | 002c9f8d8f9842b9959f3f52bcc3b5be | 0 | 233240.00 | 536781.54 | 759333.33 | 2748900.00 | 0 | 0 | 0 | 0 | nan | BacNinh | 0 | 0 | 0 | 0 | 0 | 0 | 1.00 | 1.00 | 1 | 0.00 | 0.00 | 0.00 | 1.00 | 1.00 | 0 | 0 | 0 | 0 | 1.00 | 1.00 | 0 | 0 | 0 | 0 | 2019-09-30 | 9 |
Last rows
| Age | avg_cash_1m | avg_cash_3m | avg_cash_6m | avg_loan_1m | avg_loan_3m | avg_loan_6m | avg_portfolio_value_1m | avg_portfolio_value_3m | avg_portfolio_value_6m | avg_profit_per_6m | avg_stock_count_1m | avg_stock_count_3m | avg_stock_count_6m | buy_order | buy_order_1m | buy_order_3m | buy_order_6m | buy_orders_1m_3m_per | buy_orders_1m_6m_per | cash_vs_1m | cash_vs_3m | cash_vs_6m | CashBalance | Gender | loan_vs_1m | loan_vs_3m | loan_vs_6m | LoanBalance | main_account | num_oder | port_value_vs_1m | port_value_vs_3m | port_value_vs_6m | portfolio_value | profit | profit_1m | profit_3m | profit_6m | profit_per | region | sell_order | sell_order_1m | sell_order_3m | sell_order_6m | sell_order_gain | sell_order_loss | sell_orders_1m_3m_per | sell_orders_1m_6m_per | stock_count | stock_count_vs_1m | stock_count_vs_3m | stock_count_vs_6m | total_buy_order_1m_3m_per | total_buy_order_1m_6m_per | total_buy_value | total_buy_value_1m | total_buy_value_3m | total_buy_value_6m | total_sell_order_1m_3m_per | total_sell_order_1m_6m_per | total_sell_value | total_sell_value_1m | total_sell_value_3m | total_sell_value_6m | trading_date | trading_month | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13594 | 32 | 1582745.00 | 1922349.22 | 1995344.72 | nan | nan | 68307961.46 | 34596000.00 | 36012923.08 | 55203634.92 | -0.04 | 1.00 | 1.00 | 1.10 | 0 | 0 | 0 | 7 | 1.00 | 0.00 | -25550.00 | -365154.22 | -438149.72 | 1557195.00 | M | nan | nan | nan | nan | ffcfd3ca703a4b898dd7e84608c24ac2 | 0 | -996000.00 | -2412923.08 | -21603634.92 | 33600000.00 | 0 | 0 | 0 | -7750000 | nan | BinhDinh | 0 | 0 | 0 | 3 | 0 | 0 | 1.00 | 0.00 | 1 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0 | 0 | 0 | 85442000 | 1.00 | 0.00 | 0 | 0 | 0 | 175300000 | 2019-09-30 | 9 |
| 13595 | 51 | 458492.00 | 453035.09 | 448177.23 | nan | nan | nan | 268360.00 | 288443.08 | 296463.49 | nan | 1.00 | 1.00 | 1.00 | 0 | 0 | 0 | 0 | 1.00 | 1.00 | 0.00 | 5456.91 | 10314.77 | 458492.00 | M | nan | nan | nan | nan | ffd2140f5c4e49da9179c45e7e38c3d4 | 0 | -360.00 | -20443.08 | -28463.49 | 268000.00 | 0 | 0 | 0 | 0 | nan | HCM | 0 | 0 | 0 | 0 | 0 | 0 | 1.00 | 1.00 | 1 | 0.00 | 0.00 | 0.00 | 1.00 | 1.00 | 0 | 0 | 0 | 0 | 1.00 | 1.00 | 0 | 0 | 0 | 0 | 2019-09-30 | 9 |
| 13596 | 47 | nan | nan | nan | nan | nan | nan | 343477250.00 | 325839827.69 | 318587310.32 | nan | 1.00 | 1.00 | 1.00 | 0 | 0 | 0 | 0 | 1.00 | 1.00 | nan | nan | nan | nan | M | nan | nan | nan | nan | ffd57e6c45134224b6c81ca14fd47ec1 | 0 | 19333450.00 | 36970872.31 | 44223389.68 | 362810700.00 | 0 | 0 | 0 | 0 | nan | HCM | 0 | 0 | 0 | 0 | 0 | 0 | 1.00 | 1.00 | 1 | 0.00 | 0.00 | 0.00 | 1.00 | 1.00 | 0 | 0 | 0 | 0 | 1.00 | 1.00 | 0 | 0 | 0 | 0 | 2019-09-30 | 9 |
| 13597 | 26 | 19.00 | 383.15 | 382968.93 | 86461940.50 | 209378665.69 | 303947833.91 | 377500000.00 | 516860000.00 | 585950793.65 | -0.04 | 1.00 | 1.18 | 1.38 | 0 | 0 | 0 | 4 | 1.00 | 0.00 | 0.00 | -364.15 | -382949.93 | 19.00 | M | -66134.50 | -122982859.69 | -217552027.91 | 86395806.00 | ffdf95af414245f285c0ec4e91965595 | 0 | 2500000.00 | -136860000.00 | -205950793.65 | 380000000.00 | 0 | 0 | -39370000 | -35630000 | nan | ThaiBinh | 0 | 0 | 3 | 4 | 0 | 0 | 0.00 | 0.00 | 1 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0 | 0 | 0 | 627860000 | 0.00 | 0.00 | 0 | 0 | 416400000 | 469200000 | 2019-09-30 | 9 |
| 13598 | 41 | 41875.00 | 4726119.31 | 2443819.16 | nan | nan | nan | 229625.00 | 217833.85 | 212985.32 | nan | 1.00 | 1.00 | 1.00 | 0 | 0 | 0 | 0 | 1.00 | 1.00 | 0.00 | -4684244.31 | -2401944.16 | 41875.00 | F | nan | nan | nan | nan | ffdfbcad4f2340f78012055b4c59f3ef | 0 | 12925.00 | 24716.15 | 29564.68 | 242550.00 | 0 | 0 | 0 | 0 | nan | DVSN | 0 | 0 | 0 | 0 | 0 | 0 | 1.00 | 1.00 | 1 | 0.00 | 0.00 | 0.00 | 1.00 | 1.00 | 0 | 0 | 0 | 0 | 1.00 | 1.00 | 0 | 0 | 0 | 0 | 2019-09-30 | 9 |
| 13599 | 56 | 11985.00 | 15096199.74 | 21149290.36 | 180696692.00 | 151900093.20 | 126343114.11 | 334997500.00 | 318949630.77 | 291121111.11 | -0.06 | 2.00 | 2.09 | 2.06 | 0 | 0 | 2 | 6 | 0.00 | 0.00 | 0.00 | -15084214.74 | -21137305.36 | 11985.00 | F | -1282500.00 | 27514098.80 | 53071077.89 | 179414192.00 | ffe8f9741d61422eac913ca1fce1c95f | 0 | -447500.00 | 15600369.23 | 43428888.89 | 334550000.00 | 0 | 0 | -42424000 | -36674000 | nan | DVSN | 0 | 0 | 3 | 5 | 0 | 0 | 0.00 | 0.00 | 2 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 0 | 418900000 | 1055525000 | 0.00 | 0.00 | 0 | 0 | 364451000 | 720951000 | 2019-09-30 | 9 |
| 13600 | 36 | 152426.00 | 91283.35 | 53303.34 | 157685875.79 | 137145635.25 | 140967703.35 | 185371550.00 | 154879649.23 | 149589155.00 | 0.01 | 2.95 | 3.03 | 3.23 | 0 | 10 | 49 | 100 | 0.20 | 0.10 | 1496075.00 | 1557217.65 | 1595197.66 | 1648501.00 | M | nan | nan | nan | nan | ffef4d87ab1f4afc96255d56b1eec790 | 1 | -185371550.00 | -154879649.23 | -149589155.00 | 0.00 | -2283400 | -1465670 | 7825940 | 19404240 | -0.03 | DVSN | 1 | 12 | 42 | 80 | 0 | 1 | 0.29 | 0.15 | 1 | -2.00 | -2.00 | -2.00 | 0.15 | 0.07 | 0 | 167302000 | 1145252300 | 2508633700 | 0.27 | 0.15 | 81095000 | 378096000 | 1401763500 | 2527959500 | 2019-09-30 | 9 |
| 13601 | 29 | 25880513.00 | 17845366.26 | 15918281.18 | nan | nan | nan | 156722650.00 | 137703953.85 | 115902164.84 | 0.10 | 4.95 | 4.38 | 4.40 | 0 | 2 | 8 | 19 | 0.25 | 0.11 | -20700718.00 | -12665571.26 | -10738486.18 | 5179795.00 | F | nan | nan | nan | nan | fff283aac89f4f82ab8b931dd9a9e41e | 0 | 13941350.00 | 32960046.15 | 54761835.16 | 170664000.00 | 0 | -1840000 | 24026700 | 38928300 | nan | DVSN | 0 | 1 | 3 | 4 | 0 | 0 | 0.33 | 0.25 | 5 | 0.00 | 1.00 | 1.00 | 0.60 | 0.39 | 0 | 158300000 | 262594000 | 410964000 | 0.12 | 0.09 | 0 | 24000000 | 192280000 | 253810000 | 2019-09-30 | 9 |
| 13602 | 29 | 1371899.00 | 1832260.38 | 2031132.77 | nan | nan | nan | 7853067.00 | 13069290.77 | 14585347.14 | -0.08 | 2.30 | 2.31 | 2.01 | 0 | 0 | 1 | 2 | 0.00 | 0.00 | -1371323.00 | -1831684.38 | -2030556.77 | 576.00 | M | nan | nan | nan | nan | fff942970c8d4976993aa8e949f2c228 | 0 | -7803017.00 | -13019240.77 | -14535297.14 | 50050.00 | 0 | -870000 | -2153100 | -2153100 | nan | HCM | 0 | 2 | 3 | 3 | 0 | 0 | 0.67 | 0.67 | 1 | -1.00 | -1.00 | -1.00 | 0.00 | 0.00 | 0 | 0 | 7000000 | 14200000 | 0.60 | 0.60 | 0 | 13330000 | 22156600 | 22156600 | 2019-09-30 | 9 |
| 13603 | 35 | 466813.00 | 3551778.28 | 2337714.13 | nan | nan | nan | 656058382.50 | 708738775.38 | 748528542.86 | nan | 1.00 | 1.00 | 1.00 | 0 | 1 | 1 | 1 | 1.00 | 1.00 | 0.00 | -3084965.28 | -1870901.13 | 466813.00 | F | nan | nan | nan | nan | fff95069a1554792bfe041e2f7b184bc | 0 | 81956317.50 | 29275924.62 | -10513842.86 | 738014700.00 | 0 | 0 | 0 | 0 | nan | DVSN | 0 | 0 | 0 | 0 | 0 | 0 | 1.00 | 1.00 | 1 | 0.00 | 0.00 | 0.00 | 1.00 | 1.00 | 0 | 32720400 | 32720400 | 32720400 | 1.00 | 1.00 | 0 | 0 | 0 | 0 | 2019-09-30 | 9 |